<!doctype html public "-//W3C//DTD HTML 4.01//EN">

<html>

   <head>
      <title>Inventory</title>
      <meta http-equiv="generator" content="PHP Designer 2005" />
      <style type="text/css">
        @import url(style.css);
      </style>
   </head>

   <body bgcolor="#FFFFFF" text="#000000" link="#0000FF" vlink="#800080" alink="#FF0000">

    <table align='center' class='title'>
        <tr>
            <td align='center'>INVENTORY OF BOOKS/OFFICE EQUIPMENT/FURNITURES/FIXTURES</td>
        </tr>
        <tr>
            <td align='center'>AND SEMI-EXPENDABLE SUPPLIES AND MATERIALS</td>
        </tr>
        <?php
            //$today = date("Y-m-d",time());
            $today = date("F 22, Y ");
            echo"<tr><td> As of $today</td></tr>";
        ?>
    </table>
    <br />
    <table border='1' align='center'  width='100%'>
        <tr align='center'>
            <td width='50'>ARTICLE/DESCRIPTION</td><td width='20'>UNIT VALUE</td><td width='15'>QUANTITY/UNIT</td><td width='30'>REMARKS</td>
            </tr>
        <?php
            
            
            $libraryNo = $_COOKIE['libraryNo'];
            require('db_connection.php');
            $query2 = "SELECT * FROM tblcollection WHERE libraryNo='$libraryNo'";
            $result2 = mysql_query($query2);
            while ($row = mysql_fetch_array($result2))
            {
              $title = $row['title'];
              $copyNo = $row['copyNo'];
              $yearPub = $row['yearPub'];
              echo "<tr align='left'><td width='50'>$title , $yearPub</td><td width='20'></td><td width='15' align='center'>$copyNo pcs.</td><td width='30'>No record for price</td></tr>";

            }
        ?>
        
        
    </table>
    



   </body>
</html>
